| Name | Description |
| ActivateLearnerAssignmentRight | Contains constants related to the ActivateLearnerAssignmentRight right. |
| ActivityAttemptItem | Contains constants related to the ActivityAttemptItem item type. Each item contains information about one activity in the context of one attempt. This LearningStore item type is available in both SLK and MLC. |
| ActivityObjectiveItem | Contains constants related to the ActivityObjectiveItem item type. Each item contains information about one local objective of one activity within one e-learning package. Objectives that are added to a package by a SCO via the RTE are not included in this table. This LearningStore item type is available in both SLK and MLC. |
| ActivityPackageItem | Contains constants related to the ActivityPackageItem item type. Each item contains information about one activity within one e-learning package. This LearningStore item type is available in both SLK and MLC. |
| ActivityPackageItemView | Contains constants related to the ActivityPackageItemView view. |
| AddPackageReferenceRight | Contains constants related to the AddPackageReferenceRight right. |
| AssignmentItem | Contains constants related to the AssignmentItem item type. Each item of this LearningStore item type contains information about one assignment, i.e. one organization of one e-learning package, or one non-e-learning document, assigned to one or more learners, with zero or more instructors. |
| AssignmentListForInstructors | Contains constants related to the AssignmentListForInstructors view. Each row of this LearningStore view contains information about one assignment, as well as information about the e-learning package (if any) associated with the assignment. This view contains one row for each assignment for which the current user is an instructor. |
| AssignmentPropertiesView | Contains constants related to the AssignmentPropertiesView view. This LearningStore view contains information about one SLK assignment, as specified by the "AssignmentId" view parameter (the AssignmentItemIdentifier of an assignment) and the "IsInstructor" view parameter (true if the current user is an instructor on the assignment, false if they're a learner). |
| AttemptItem | Contains constants related to the AttemptItem item type. Each item contains information about one attempt, i.e. one instance of one learner executing one organization of one e-learning package. If the same learner attempts the same organization twice, two AttemptItem rows are created. This LearningStore item type is available in both SLK and MLC. SLK extends this item type by adding the LearnerAssignmentId property/column and a SQL index. |
| AttemptObjectiveItem | Contains constants related to the AttemptObjectiveItem item type. Each item contains information about the learner's progress on one local objective for one activity of one attempt. This LearningStore item type is available in both SLK and MLC. |
| CommentFromLearnerItem | Contains constants related to the CommentFromLearnerItem item type. Each item contains one comment from the learner related to one activity of one attempt. This LearningStore item type is available in both SLK and MLC. |
| CommentFromLmsItem | Contains constants related to the CommentFromLmsItem item type. Each item contains a "comments from LMS" string related to a specific activity within an e-learning package. These are read-only by SCOs. SLK does not add rows to the CommentsFromLmsItem table. This LearningStore item type is available in both SLK and MLC. |
| CompleteLearnerAssignmentRight | Contains constants related to the CompleteLearnerAssignmentRight right. |
| CorrectResponseItem | Contains constants related to the CorrectResponseItem item type. Each item contains information about one SCORM correct response string for one InteractionItem. The CorrectResponseItem table contains one row in this table per correct response per interaction. This LearningStore item type is available in both SLK and MLC. |
| CreateAttemptRight | Contains constants related to the CreateAttemptRight right. |
| DeleteAttemptRight | Contains constants related to the DeleteAttemptRight right. |
| EvaluationCommentItem | Contains constants related to the EvaluationCommentItem item type. Each item contains a comment from an evaluator (i.e. an instructor grading a learner assignment) related to one InteractionItem. Only used for e-learning packages in Class Server format. This LearningStore item type is available in both SLK and MLC. |
| ExecuteSessionRight | Contains constants related to the ExecuteSessionRight right. |
| ExtensionDataItem | Contains constants related to the ExtensionDataItem item type. Each item contains one "extension" data model element. An "extension" data model element is a data model element whose name does not begin with "cmi." or "adl.". This LearningStore item type is available in both SLK and MLC. |
| FinalizeLearnerAssignmentRight | Contains constants related to the FinalizeLearnerAssignmentRight right. |
| FinishLearnerAssignmentRight | Contains constants related to the FinishLearnerAssignmentRight right. |
| GlobalObjectiveItem | Contains constants related to the GlobalObjectiveItem item type. Each item contains information about one global objective related to one organization of one e-learning package, or one global objective that's not constrained to any one organization of any package. This LearningStore item type is available in both SLK and MLC. |
| InstructorAssignmentItem | Contains constants related to the InstructorAssignmentItem item type. Each item of this LearningStore item type contains information about one instructor assignment, i.e. the mapping of one instructor to one assignment. For example, if an assignment has three instructors, there will be three InstructorAssignmentItem table rows associated with that assignment. |
| InstructorAssignmentListForInstructors | Contains constants related to the InstructorAssignmentListForInstructors view. Each row of this LearningStore view contains information about one instructor assignment, as well as information about the e-learning package (if any) associated with the assignment. This view returns one row for each instructor on each assignment for which the current user is an instructor. |
| InteractionItem | Contains constants related to the InteractionItem item type. Each item contains information about one interaction within one activity of one attempt. This LearningStore item type is available in both SLK and MLC. |
| InteractionObjectiveItem | Contains constants related to the InteractionObjectiveItem item type. Each item relates one InteractionItem with one AttemptObjectiveItem. This LearningStore item type is available in both SLK and MLC. |
| LearnerAssignmentItem | Contains constants related to the LearnerAssignmentItem item type. Each item of this LearningStore item type contains information about one learner assignment, i.e. the mapping of one learner to one assignment. For example, if an assignment has 30 learners, there will be 30 LearnerAssignmentItem table rows associated with that assignment. |
| LearnerAssignmentListForInstructors | Contains constants related to the LearnerAssignmentListForInstructors view. Each row of this LearningStore view contains information about one learner assignment, as well as information about the e-learning package (if any) associated with the assignment. This view returns one row for each learner on each assignment for which the current user is an instructor. |
| LearnerAssignmentListForLearners | Contains constants related to the LearnerAssignmentListForLearners view. Each row of this LearningStore view contains information about one learner assignment, as well as information about the e-learning package (if any) associated with the assignment. This view returns one row for each assignment for which the current user is a learner, excluding assignments which have not yet started. |
| LearnerAssignmentView | Contains constants related to the LearnerAssignmentView view. This LearningStore view contains specific information about all learner assignments. By default, access is granted to no users; consider using other views. |
| LearnerGlobalObjectiveItem | Contains constants related to the LearnerGlobalObjectiveItem item type. Each item contains information about the progress of one learner against a particular global objective, across all activities in all e-learning packages. These objectives may be global to a single package or global to the system -- the data in this table does not distinguish between these two cases. This LearningStore item type is available in both SLK and MLC. |
| MapActivityObjectiveToGlobalObjectiveItem | Contains constants related to the MapActivityObjectiveToGlobalObjectiveItem item type. Each item contains a mapping between an ActivityObjectiveItem and a GlobalObjectiveItem. This LearningStore item type is available in both SLK and MLC. |
| PackageGlobalObjectiveItem | Contains constants related to the PackageGlobalObjectiveItem item type. Each item contains information about progress on one global objective related to one organization. This LearningStore item type is available in both SLK and MLC. |
| PackageItem | Contains constants related to the PackageItem item type. Each item contains information about one e-learning package. Before a package can be attempted, a row referring to it must be added to this table. When that happens, detailed information about the package is added to other tables in the schema; for example, information about each activity is added to the ActivityPackageItem table. SLK extends this item type by adding the Warnings property/column. This LearningStore item type is available in both SLK and MLC. |
| RandomAccessSessionRight | Contains constants related to the RandomAccessSessionRight right. |
| ReadPackageRight | Contains constants related to the ReadPackageRight right. |
| RemovePackageReferenceRight | Contains constants related to the RemovePackageReferenceRight right. |
| ResourceItem | Contains constants related to the ResourceItem item type. Each item contains information about resources used in activities, including the XML of each <resource> element in the package. This LearningStore item type is available in both SLK and MLC. |
| ReviewSessionRight | Contains constants related to the ReviewSessionRight right. |
| RubricItem | Contains constants related to the RubricItem item type. Each item contains information about a rubric that is attached to an interaction. This LearningStore item type is available in both SLK and MLC. |
| SeqNavActivityAttemptView | Contains constants related to the SeqNavActivityAttemptView view. |
| SeqNavActivityPackageView | Contains constants related to the SeqNavActivityPackageView view. |
| SeqNavActivityTreeView | Contains constants related to the SeqNavActivityTreeView view. |
| SeqNavAttemptCommentFromLearnerView | Contains constants related to the SeqNavAttemptCommentFromLearnerView view. |
| SeqNavAttemptCorrectResponseView | Contains constants related to the SeqNavAttemptCorrectResponseView view. |
| SeqNavAttemptEvaluationCommentLearnerView | Contains constants related to the SeqNavAttemptEvaluationCommentLearnerView view. |
| SeqNavAttemptExtensionDataView | Contains constants related to the SeqNavAttemptExtensionDataView view. |
| SeqNavAttemptInteractionExtensionDataView | Contains constants related to the SeqNavAttemptInteractionExtensionDataView view. |
| SeqNavAttemptInteractionObjectiveView | Contains constants related to the SeqNavAttemptInteractionObjectiveView view. |
| SeqNavAttemptInteractionView | Contains constants related to the SeqNavAttemptInteractionView view. |
| SeqNavAttemptObjectiveExtensionDataView | Contains constants related to the SeqNavAttemptObjectiveExtensionDataView view. |
| SeqNavAttemptObjectiveView | Contains constants related to the SeqNavAttemptObjectiveView view. |
| SeqNavAttemptRubricView | Contains constants related to the SeqNavAttemptRubricView view. |
| SeqNavAttemptView | Contains constants related to the SeqNavAttemptView view. |
| SeqNavCurrentActivityAttemptView | Contains constants related to the SeqNavCurrentActivityAttemptView view. |
| SeqNavCurrentCommentFromLmsView | Contains constants related to the SeqNavCurrentCommentFromLmsView view. |
| SeqNavLearnerGlobalObjectiveView | Contains constants related to the SeqNavLearnerGlobalObjectiveView view. |
| SeqNavOrganizationGlobalObjectiveView | Contains constants related to the SeqNavOrganizationGlobalObjectiveView view. |
| SequencingLogEntryItem | Contains constants related to the SequencingLogEntryItem item type. Each item contains one sequencing log entry, related to one activity of one attempt, or related to an entire attempt. See StoredLearningSession.LoggingOptions. This LearningStore item type is available in both SLK and MLC. |
| SiteSettingsItem | Contains constants related to the SiteSettingsItem item type. Each item of this LearningStore item type contains the SLK Settings corresponding to a given SharePoint site collectino (SPSite). |
| StartAttemptOnLearnerAssignmentRight | Contains constants related to the StartAttemptOnLearnerAssignmentRight right. |
| UserItem | Contains constants related to the UserItem item type. Each item contains information about one user, including a numeric identifier (UserItemIdentifier) used elsewhere in the database to refer to the user. UserItem items contain a Key property (database column) which, for SLK, contains either the security ID (SID) of the user or the user's login name. (The login name is used for authentication mechanisms such as forms-based authentication which don't use security IDs.) This LearningStore item type is available in both SLK and MLC. SLK extends this item type by granting access to all users. |
| UserWebList | Contains constants related to the UserWebList view. Each row of this LearningStore view represents one entry in one user's "user Web list", for one site collection. A user Web list is the list of Web sites that appears on the SLK E-Learning Actions page for all document libraries within a given site collection. Each user has at most one user Web list for each site collection (SPSite). |
| UserWebListItem | Contains constants related to the UserWebListItem item type. Each item of this LearningStore item type represents one entry in one user's user Web list, for one site collection. A user Web list is the list of Web sites that appears on the SLK E-Learning Actions page for all document libraries within a given site collection. Each user has at most one user Web list for each site collection (SPSite). |